home *** CD-ROM | disk | FTP | other *** search
/ .net 2002 March / DotNetMagazine-Issue107-Coverdisc-NET107-02-03-PCMac.bin / pc / PC Software / Coldfusion / coldfusion-60-win-en.exe / docwindow.cfm < prev    next >
Encoding:
Text File  |  2002-01-15  |  527 b   |  16 lines
  1. and tblDepartments.departmentName like '%#department#%'</cfif>
  2.         ORDER BY tblEmployees.LastName, tblEmployees.FirstName
  3.         </cfquery>
  4.             
  5.         <!--- return the resulting query object to Flash --->
  6.         <cfreturn empQry>
  7.  
  8.     </cffunction>
  9.  
  10.  
  11.     <cffunction name="getDepartments" access="remote" returnType="query" hint="This query returns all unique departments in the employee database.">
  12.  
  13.         <cfquery name="qDepartments" datasource="exampleapps">
  14.         SELECT DISTINCT DepartmentName AS department 
  15.         FROM tblDepartments
  16.         </cfq